Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# What's New in the OLAP DML?

This section identifies the new features of the Oracle Database 10g that relate to the OLAP DML and lists the Oracle OLAP DML statements that were added, changed, renamed, or deleted in Oracle 9i and Oracle 10g.

- New Features in the OLAP DML

- OLAP DML Statement Changes for Oracle 10g

- OLAP DML Statement Changes for Oracle 9i

## New Features in the OLAP DML

In Oracle 10g, the following changes were made to the Oracle OLAP DML:

- Multiwriter Support

- Aggregation Enhancements

- Allocation Enhancements

- Custom Member Enhancements

- Partitioned Variable Support

- Object Event Support

- Multi-Language Support

- Related Dimension and Relation Enhancements

- LIMIT and QDR Enhancements

- Enhanced Sorting and Ranking Functionality

- Additional Features

See also: "OLAP DML Statement Changes for Oracle 10g" and "OLAP DML Statement Changes for Oracle 9i" identify, by name, the OLAP DML statements that were added, changed, renamed, or deleted in various releases of Oracle 9i and Oracle 10g.

### Multiwriter Support

In Oracle 10g, you can attach an analytic workspace in multiwriter access mode. A workspace that is attached in multiwriter mode can be accessed simultaneously by several sessions and users can simultaneously modify the same analytic workspace in a controlled manner by specifying the attachment mode for individual analytic workspace objects.

See: AW ATTACH, ACQUIRE, RELEASE, RESYNC, REVERT, UPDATE, ONATTACH, and WRITABLE

### Aggregation Enhancements

In Oracle 10g, new features have been added, some default values have changed, and old functionality has been deprecated.

#### Compressed Composites

In Oracle 10g, you can use compressed composites to create variables with the fewest stored aggregated values. Using compressed composites improves performance and decreases the space needed to store aggregate values. A compressed composite contains one composite tuple for each set of base dimension values that identifies non-NA detail data in the variables that use it. Additionally, for variables dimensioned by compressed composite Oracle OLAP reduces redundancy in the variable, composite, and composite index by creating a physical position in the composite only for those tuples that represent a parent with more than one descendant

Oracle OLAP compresses the data in variables dimensioned by compressed composites using the "intelligence" of the AGGREGATE command or AGGREGATE function. In Oracle 10g, though there are still some special considerations that apply when aggregating a variable dimensioned by one or more compressed composites, these considerations are less restrictive than in earlier releases.

See Also: DEFINE COMPOSITE, "Aggregating Variables Dimensioned by Compressed Composites"

#### Aggregation Advisor

In Oracle 10g, within an aggregation specification, you can access special Oracle OLAP functionality called the Aggregate Advisor. Using the Aggregate Advisor you can request that Oracle OLAP determine the values that are aggregated as a database maintenance procedure and those aggregated on-the-fly to give the best performance and storage.

See: PRECOMPUTE statement, and the PRECOMPUTE clause in the RELATION (for aggregation) statement

#### Additional Aggregation Enhancements

In Oracle 10g, the new features have also improved the aggregation capabilities of Oracle OLAP:

- You can perform hierarchical and non-hierarchical aggregation across data objects.

  See: "Aggregations"

- You can specify computation based on the position of dimension values and hierarchical level.

  See: RELATION (for aggregation)

- You can specify default an aggregation specification for a variables.

  See: $AGGMAP property

#### Changed and Deprecated Aggregation Statements and Parameters

The default values for the CACHE statement in an aggregation specification has changed.

The the following aggregation statements and parameters were deprecated:

- The ROLLUP statement was deprecated as of Oracle 10g Release 1 (10.1.0.3). Although the ROLLUP statement offered a way of performing simple additive aggregation through a single OLAP DML statement. However, ROLLUP was not compatible with many new features (for example, aggmap objects and compressed composites). Beginning with Oracle 10g Release 1, define your aggregations using aggmap objects as discussed in "Aggregations".

- For the AGGREGATE command and the AGGREGATE function:

  - The WAGG and WNOAGG weighted operators have been deprecated. WPREAGG is now the default for all weighted operators.

  - The WAGG and WNOAGG weighted operators have been deprecated. WPREAGG is now the default for all weighted operators.

  - Arbitrary LIMIT syntax in PRECOMPUTE statements has been deprecated.

    For example, the following syntax is not supported:

        PRECOMPUTE(limit(b to first 5))

    Instead, (1) define a valueset, (2) define an aggmap object that uses the valueset that you defined in step 1, (3) assign values to the valueset that you defined in step 1, and then (3) execute an AGGREGATE statement using the aggmap that you defined in step 2. For example:

        DEFINE time.precomp VALUESET time

          DEFINE myaggmap AGGMAP
          AGGMAP
          RELATION time.parentrel PRECOMPUTE(time.precomp)
          END

          LIMIT time.precomp TO FIRST 5
          AGGREGATE myvar USING myaggmap

- In previous releases, the syntax for the ANY, AVERAGE, COUNT, EVERY, LARGEST, MEDIAN, NONE, SMALLEST, STDDEV, TALLY, and TOTAL functions included a STATUS keyword that specified the status of a temporary variable sometimes used by these functions. Improvements negated the need for a temporary variable and, consequently, the STATUS keyword in these functions has been deprecated.

### Allocation Enhancements

In Oracle 10g, there are new features that improve the allocation capabilities or Oracle OLAP:

- You can allocate data to variable dimensioned by a non-hierarchical dimension such as a measure or line dimension.

  See: VALUESET

- You can specify a default allocation specification for a variable.

  See: $ALLOCMAP

### Partitioned Variable Support

An analytic workspace is a table of LOBs with each analytic workspace object one or more rows in the table. In Oracle 10g, you can explicitly specify which parts of a variable you want to be in a row or LOB by defining a partitioned variable—each partition is a row or LOB. Once you have defined the partitions of a variable, you can maintain these partitions explicitly.

See: DEFINE PARTITION TEMPLATE, DEFINE VARIABLE, MAINTAIN ADD TO PARTITION, MAINTAIN MOVE TO PARTITION, PARTITIONCHECK

### Custom Member Enhancements

In Oracle 10g, you can add and delete one or more temporary calculated members (sometimes called custom members) to a dimension and apply those members to a variable; or apply a previously-defined calculated member to the a variable. You can test to see if a dimension value is a custom member. Also, you can limit a dimension to custom member values.

See: MAINTAIN ADD SESSION, ISSESSION, the SESSION keyword of the LIMIT command (using values) and MAINTAIN DELETE dimension

### Multi-Language Support

In Oracle 10g, enhancements have been made to allow you to create applications in multiple languages using a language dimension.

See: "Working with Language Dimensions", $DEFAULT_LANGUAGE, LOCK_LANGUAGE_DIMS, SESSION_NLS_LANGUAGE, and STATIC_SESSION_LANGUAGE

### Related Dimension and Relation Enhancements

In Oracle 10g, enhancements have been made for working with related dimensions and relations:

- When two dimensions share more than one relation, you can explicitly specify a default relation that Oracle OLAP uses when performing calculations based on related dimensions.

  See: RELATION command, OBJ, LIMIT command (using related dimension)

- When limiting based on the values of a related dimension, you can explicitly specify the relation by which to perform the limit; and, if the relation is a multidimensional relation, you can specify what values of the relation to use.

  See: LIMIT command (using LEVELREL), LIMIT command (using related dimension), and LIMIT command (using parent relation)

### Object Event Support

In Oracle 10g, you can specify that the DEFINE, MAINTAIN, PROPERTY, SET (=) UPDATE, and AW commands are events that trigger the execution of previously-created OLAP DML programs.

See: "Trigger Programs"

### LIMIT and QDR Enhancements

In Oracle 10g, the following changes have been made for managing dimension status:

- You can order the results of a LIMIT based on the order of the selection arguments rather than the current status order. Additionally, you can LIMIT to values of custom members; and, when you limit using a parent relation, you can specify that you only want the top or the bottom members of a hierarchy in status.

  See: LIMIT command, LIMIT function

- There is additional support for using CHGDIMS to manage dimension status.

- There is support for specifying dimension status within the syntax of the RANK function.

- There is support for nonexistent values in LIMIT statements and QDRs.

  See: LIMITSTRICT

- You can set the current status list of one or more base dimensions of a composite, conjoint dimension, concat dimension, or a partition template based on the selected values of that object. You can also assign a value to one or more valuesets for the base dimensions.

  See:: LIMIT BASEDIMS

- You can identify how many times the status of a dimension has changed and explicitly identify a previous status list for which you want to retrieve values.

  See:: STATDEPTH function, STATDEPTH of the LIMIT function

### Enhanced Sorting and Ranking Functionality

In Oracle 10g, the LIMIT and SORT commands were modified to allow you to sort by hierarchy and to specify whether `NA` values appear first or list in the sorted list. A SORT function was added with which you can retrieve the sorted values. Additionally, the performance of the RANK function has been enhanced and various options have been added to let you monitor its performance.

See: SORT command, SORT function, LIMIT command (with SORT keyword), RANK, RANK_CALLS, RANK_CELLS, and RANK_SORTS

### Additional Features

Oracle 10g also includes the following OLAP DML features:

- New attachment program

  In Oracle 10g, you can create a new attachment program named `ONATTACH` that will execute before any other attachment program. Frequently, this program is used to specify the attachment mode for individual analytic workspace objects when an analytic workspace is attached in multiwriter mode.

  See: ONATTACH

- Improved error handling when reading files

  In Oracle 10g, you can specify the behavior of Oracle OLAP when an error is reached when reading from a file using an INFILE statement.

  See: INF_STOP_ON_ERROR

- Additional support for the OLAP_TABLE function used in SQL

  In Oracle 10g, you can set an upper limit on the size of a data block generated by a FETCH statement specified in the OLAP_command parameter of the `OLAP_TABLE` function in SQL.

  See: MAXFETCH

- Extended support for embedded SQL

  In Oracle 10g, you can select data from relational tables into analytic workspace objects without using an explicit cursor.

  See: SQL SELECT

- New SQL-like text and numerical functions

  In Oracle 10g, a number of functions that are familiar to SQL programmers were added to the OLAP DML.

  See: ARCTAN2, ASCII, BITAND, COALESCE, DECODE, EXP, GREATEST, INITCAP, INSTR, INSTRB, LEAST, LPAD, LTRIM, NULLIF, NVL, NVL2, RPAD, RTRIM, SIGN, SUBSTR, SUBSTRB, TRIM, and WIDTH_BUCKET

- Change in default display of long error messages.

  Beginning in 10.2, by default, long error messages are not wrapped when displayed. When you want the previous default behavior which is to display long error messages as multiple lines with each line being 72 characters in length, set the WRAPERRORS option to `YES`.

- Additional keywords in the AW function and OBJ function that let you retrieve more information about Oracle OLAP and your analytic workspace.

- Additional support for using the current status list rather than the default status list.

  By including the new STATUS keyword you can compute the depreciation expenses for a series of assets, the interest portion of the payments on a series of loans, or a payment schedule for paying off a series of installment loans using based on the current status list.

  See: DEPRDECL, DEPRDECLSW, DEPRSL, DEPRSOYD, FINTSCHED, FPMTSCHED, VINTSCHED, VPMTSCHED

## OLAP DML Statement Changes for Oracle 10g

This section contains listings of the OLAP DML statements that were added, changed, renamed, or deleted in Oracle 10g.

- Statements Added in Oracle 10g

- Statements Deleted in Oracle 10g

- Statements Changed in Oracle 10g

- Statements Renamed in Oracle 10g

### Statements Added in Oracle 10g

The following statements have been added to the OLAP DML in Oracle 10g. The number in parentheses indicates the specific release in which the statement was added.

AGGCOUNT (10.2.0.0)
$AGGMAP (10.1.0.0)
$AGGREGATE_FORCECALC (10.2.0.0)
$AGGREGATE_FORCEORDER (10.2.0.0)
$AGGREGATE_FROM (10.1.0.0)
$AGGREGATE_FROMVAR (10.1.0.0)
$ALLOCMAP (10.1.0.0)
$COUNTVAR (10.1.0.0)
$DEFAULT_LANGUAGE (10.2.0.0)
ACQUIRE (10.1.0.0)
AGGROPS (10.2.0.0)
ALLOCOPS (10.2.0.0)
ARCTAN2 (10.1.0.0)
ASCII (10.1.0.0)
AW TRUNCATE (10.1.0.3)
BITAND (10.1.0.0)
COALESCE (10.1.0.0)
DECODE (10.1.0.0)
DEFINE PARTITION TEMPLATE (10.1.0.0)
DROP DIMENSION (10.1.0.0)
EXP (10.1.0.0)
GREATEST (10.1.0.0)
INF_STOP_ON_ERROR (10.1.0.0)
INITCAP (10.1.0.0)
INSTR (10.1.0.0)
INSTRB (10.1.0.0)
LEAST (10.1.0.0)
LPAD (10.1.0.0)
LIMIT BASEDIMS (10.2.0.0)
LOCK_LANGUAGE_DIMS (10.2.0.0)
LTRIM (10.1.0.0)
MAXFETCH (10.1.0.0)
NULLIF (10.1.0.0)
NVL (10.1.0.0)
NVL2 (10.1.0.0)
ONATTACH (10.1.0.0)
PARTITIONCHECK (10.1.0.0)
PRECOMPUTE (10.2.0.0)
RANK_CALLS (10.2.0.0)
RANK_CELLS (10.2.0.0)
RANK_SORTS (10.2.0.0)
RELATION command (10.2.0.0)
RELEASE (10.1.0.0)
RESYNC (10.1.0.0)
REVERT (10.1.0.0)
RPAD (10.1.0.0)
RTRIM (10.1.0.0)
SESSION_NLS_LANGUAGE (10.2.0.0)
SET1 (10.1.0.0)
SIGN (10.1.0.0)
SORT function (10.2.0.0)
STATDEPTH (10.2.0.0)
STATIC_SESSION_LANGUAGE (10.2.0.0)
SUBSTR (10.1.0.0)
SUBSTRB (10.1.0.0)
SQLFETCH (10.2.0.0)
TRIGGER command (10.1.0.0)
TRIGGER function (10.1.0.0)
TRIGGER_DEFINE (10.1.0.0)
TRIGGER_AFTER_UPDATE (10.1.0.0)
TRIGGER_BEFORE_UPDATE (10.1.0.0)
TRIGGERASSIGN (10.1.0.0)
TRIM (10.1.0.0)
USETRIGGERS (10.1.0.0)
VALUESET (10.1.0.0)
WIDTH_BUCKET (10.1.0.0)
WRAPERRORS (10.2.0.0)
WRITABLE (10.2.0.0)

### Statements Deleted in Oracle 10g

The following statements have been deleted from the OLAP DML in Oracle 10g. The number in parentheses indicates the specific release in which the statement was deleted.

AW ALLOCATE (10.1.0.0)
ROLLUP (10.2.0.0)

### Statements Changed in Oracle 10g

The following OLAP DML statements were significantly changed in Oracle 10g. Examples of significant changes are the addition of a new keyword or a change in a default value. The number in parentheses indicates the last release in which the statement was significantly changed.

AGGMAPINFO (10.1.0.0)
AGGREGATE command (10.2.0.0)
AGGREGATE function (10.2.0.0)
ARGUMENT (10.1.0.0)
ANY (10.2.0.0)
AVERAGE (10.2.0.0)
AW function (10.2.0.0)
AW ATTACH (10.1.0.0)
CACHE (10.2.0.0)
CHGDFN (10.2.0.0)
CHGDIMS (10.1.0.3)
COUNT (10.2.0.0)
DEFINE COMPOSITE (10.1.0.0)
DEFINE VARIABLE (10.2.0.0)
DEPRDECL (10.2.0.0)
DEPRDECLSW (10.2.0.0)
DEPRSL (10.2.0.0)
DEPRSOYD (10.2.0.0)
EVERY (10.2.0.0)
FINTSCHED (10.2.0.0)
FPMTSCHED (10.2.0.0)
LARGEST (10.2.0.0)
LIMIT command (10.2.0.0)
LIMIT function (10.2.0.0)
MAINTAIN ADD SESSION (10.1.0.0)
MAINTAIN ADD TO PARTITION (10.1.0.0)
NONE (10.2.0.0)
RANK (10.2.0.0)
RELATION (for aggregation) (10.2.0.0)
SMALLEST (10.2.0.0)
SORT command (10.1.0.3)
SQL (10.1.0.0)
STDDEV (10.2.0.0)
TALLY (10.2.0.0)
TOTAL (10.2.0.0)
UPDATE (10.1.0.0)
VARIABLE (10.1.0.0)
VALSPERPAGE (10.1.0.0)
VINTSCHED (10.2.0.0)
VPMTSCHED (10.2.0.0)

### Statements Renamed in Oracle 10g

No OLAP DML statements have been renamed in Oracle 10g.

## OLAP DML Statement Changes for Oracle 9i

This section contains listings of the OLAP DML statement changes in Oracle 9i.

- Statements Added in Oracle 9i

- Statements Deleted in Oracle 9i

- Statements Changed in Oracle 9i

- Statements Renamed in Oracle 9i

### Statements Added in Oracle 9i

The following statements were added to the OLAP DML in Oracle 9i. The number in parentheses indicates the specific release in which the statement was added.

ADD_MONTHS (9.0.0.0)
ALLOCATE (9.2.0.0)
ALLOCERRLOGFORMAT (9.2.0.0)
ALLOCERRLOGHEADER (9.2.0.0)
ALLOCMAP (9.2.0.0)
BASEDIM (9.2.0.0)
BASEVAL (9.2.0.0)
CDA (9.2.0.0)
CEIL (9.0.0.0)
CHANGEBYTES (9.0.0.0)
CHGDIMS (9.2.0.0)
CHILDLOCK (9.2.0.0)
COMMIT (9.2.0.0)
DEADLOCK (9.2.0.0)
ERRORLOG (9.2.0.0)
ERRORMASK (9.2.0.0)
EXTBYTES (9.0.0.0)
FETCH (9.2.0.0)
FINDBYTES (9.0.0.0)
FLOOR (9.0.0.0)
GROUPINGID (9.2.0.0)
HIERHEIGHT command (9.2.0.0)
HIERHEIGHT function (9.2.0.0)
INSBYTES (9.0.0.0)
JOINBYTES (9.0.0.0)
LAST_DAY (9.0.0.0)
LIMITMAPINFO (9.2.0.2)
LIMITSTRICT (9.2.0.2)
MAXBYTES (9.0.0.0)
MAXFETCH (9.0.0.0)
MONTHS_BETWEEN (9.0.0.0)
MULTIPATHHIER (9.0.0.0)
NEW_TIME (9.0.0.0)
NEXT_DAY (9.0.0.0)
NLS Options, specifically:

  NLS_CALENDAR (9.0.0.0)
  NLS_CURRENCY (9.0.0.0)
  NLS_DATE_FORMAT (9.0.0.0)
  NLS_DATE_LANGUAGE (9.0.0.0)
  NLS_DUAL_CURRENCY (9.0.0.0)
  NLS_ISO_CURRENCY (9.0.0.0)
  NLS_LANG (9.0.0.0)
  NLS_LANGUAGE (9.0.0.0)
  NLS_NUMERIC_CHARACTERS (9.0.0.0)
  NLS_SORT (9.0.0.0)
  NLS_TERRITORY (9.0.0.0)

NULLIF (9.0.0.0)
POUTFILEUNIT (9.2.0.0)
REMBYTES (9.0.0.0)
REPLBYTES (9.0.0.0)
ROLE (9.0.0.0)
SOURCEVAL (9.2.0.0)
SYSDATE (9.0.0.0)
TO_CHAR (9.0.0.0)
TO_DATE (9.0.0.0)
TO_NCHAR (9.2.0.0)
TO_NUMBER (9.0.0.0)
TRACEFILEUNIT (9.2.0.0)
TRIM (9.0.0.0)
USERID (9.0.0.0)

### Statements Deleted in Oracle 9i

The following statements have been deleted from the OLAP DML in Oracle 9i. The number in parentheses indicates the specific release in which the statement was deleted.

_UPDATEOLDVERS (9.2.0.0)
_XCALONGTIME (9.0.0.0)
_XCARETRIES (9.0.0.0)
_XCASHORTIME (9.0.0.0)
ALLOWQONS (9.2.0.0)
AW ALLOCATE (10.1.0.0)
CACHEHITS (9.2.0.0)
CACHEMISSES (9.2.0.0)
CACHETRIES (9.2.0.0)
CHARSET (9.0.0.0)
CHDIR (9.2.0.0)
CHDRIVE (9.2.0.0)
COMQUERY (9.0.0.0)
COMSET (9.0.0.0)
COMUNIT (9.0.0.0)
CONNECT (9.0.0.0)
DBEXTENDPATH (9.2.0.0)
DBGSESSION (9.2.0.0)
DBREPORT (9.2.0.0)
DBSEARCHPATH (9.2.0.0)
DBTEMPPATH (9.2.0.0)
DEFINE EXTCALL (9.0.0.0)
DGCART (9.2.0.0)
DIR (9.2.0.0)
DISCONNECT (9.0.0.0)
EPRODUCT (9.2.0.0)
ERELEASE (9.2.0.0)
EXECBREAK (9.0.0.0)
EXECSTART (9.0.0.0)
EXECSTATUS (9.0.0.0)
EXECUTE (9.0.0.0)
EXECWAIT (9.0.0.0)
EXTARGS (9.0.0.0)
FETCH (9.0.0.0) -- SNAPI
FILEMODEMASK (9.2.0.0)
IFCOPY (9.2.0.0)
LONGOBJNAMES (9.0.0.0)
MAXFETCH (9.0.0.0)
MKDIR (9.0.0.0)
NAPAGEFREE (9.2.0.0)
ODBC.CONNECTION (9.0.0.0)
ODBC.CONNLIST (9.0.0.0)
ODBC.DISCONN (9.0.0.0)
ODBC.SOURCE (9.0.0.0)
ODBC.SOURCELIST (9.0.0.0)
PGCACHEHITS (9.2.0.0)
PGCACHEMISSES (9.2.0.0)
PAGEPAUSE (9.2.0.0)
PAGEPROMPT (9.2.0.0)
PAUSE (9.2.0.0)
RETRIEVE (9.0.0.0)
RMDIR (9.0.0.0)
SESSIONQUERY (9.0.0.0)
SHARESESSION (9.0.0.0)
SHELL (9.0.0.0)
SQL CONNECT (9.0.0.0)
SQL DISCONNECT (9.0.0.0)
SQL.DMBS (9.0.0.0)
SQL.DMBSLIST (9.0.0.0)
STRIP (9.2.0.0)
THREADEXTCALL (9.0.0.0)
TRACE (9.2.0.0)
TRANSLATE (9.0.0.0)
TRANSPORT (9.0.0.0)
WATCH (9.2.0.0)
XABORT (9.0.0.0)
XCAPORTNUMBER (9.0.0.0)
XCLOSE (9.0.0.0)
XOPEN (9.0.0.0)

### Statements Changed in Oracle 9i

The following OLAP DML statements were significantly changed in Oracle 9i and have not changed since then. Examples of significant changes are the addition of a new keyword or a change in a default value. The number in parentheses indicates the last release in which the statement was significantly changed. See also "Statements Renamed in Oracle 9i" for a list of renamed statements.

CONVERT (9.2.0.0)
DECIMALCHAR (9.2.0.0)
EXPORT (9.2.0.0)
FCQUERY (9.2.0.0)
FCSET (9.2.0.0)
FILEOPEN (9.0.0.0)
FILEQUERY (9.0.0.0)
FILEREAD (9.2.0.0)
HIERHEIGHT command (9.2.0.0)
IMPORT (9.0.0.0)
INFILE (9.0.0.0)
LAG (9.2.0.2)
LAGABSPCT (9.2.0.2)
LAGDIF (9.2.0.2)
LAGPCT (9.2.0.2)
LEAD (9.2.0.2)
MODEL (9.2.0.2)
MOVINGAVERAGE (9.2.0.2)
MOVINGMAX (9.2.0.2)
MOVINGMIN (9.2.0.2)
MOVINGTOTAL (9.2.0.2)
NOSPELL (9.2.0.0)
OUTFILE (9.0.0.0)
PROGRAM (9.2.0.0)
PROPERTY (9.0.0.0)
RECURSIVE (9.0.0.0)
RELATION (for aggregation) (9.2.0.2)
RELATION (for allocation) (9.2.0.2)
ROUND (9.0.0.0)
SYSDATE (9.2.0.0)
SYSINFO (9.2.0.2)
SYSTEM (9.2.0.0)
TALLY (10.2.0.0)
THOUSANDSCHAR (9.2.0.0)
YESSPELL (9.2.0.0)

### Statements Renamed in Oracle 9i

The following OLAP DML statements were renamed in Oracle 9i. The number in parentheses indicates the specific release in which the statement was renamed.

DATABASE command to AW command (9.2.0.0)
DATABASE function to AW function (9.2.0.0)
DBDESCRIBE to AWDESCRIBE (9.2.0.0)
DBWAITTIME to AWWAITTIME (9.2.0.0)
DEFAULTDBFSIZE to DECODE (9.2.0.0)
OESEIFVERSION to EIFVERSION (9.2.0.0)